Overview

Dataset info

Number of variables56
Number of observations85273
Missing cells432054 (9.0%)
Duplicate rows0 (0.0%)
Total size in memory36.4 MiB
Average record size in memory448.0 B

Variables types

Numeric25
Categorical19
Boolean8
Date0
URL0
Text (Unique)0
Rejected4
Unsupported0

Warnings

amenities has a high cardinality: 74989 distinct values Warning
availability_30 has 39823 (46.7%) zeros Zeros
availability_365 has 28858 (33.8%) zeros Zeros
availability_60 is highly correlated with availability_30 (ρ = 0.9406128974) Rejected
availability_90 is highly correlated with availability_60 (ρ = 0.9777661242) Rejected
bedrooms has 5144 (6.0%) zeros Zeros
beds has 2090 (2.5%) zeros Zeros
calculated_host_listings_count_entire_homes is highly correlated with calculated_host_listings_count (ρ = 0.9960387541) Rejected
calculated_host_listings_count_private_rooms has 41260 (48.4%) zeros Zeros
calculated_host_listings_count_shared_rooms has 84247 (98.8%) zeros Zeros
cleaning_fee has a high cardinality: 259 distinct values Warning
cleaning_fee has 21530 (25.2%) missing values Missing
extra_people has a high cardinality: 114 distinct values Warning
first_review has a high cardinality: 2759 distinct values Warning
first_review has 21004 (24.6%) missing values Missing
host_since has a high cardinality: 3418 distinct values Warning
host_verifications has a high cardinality: 548 distinct values Warning
id is highly correlated with df_index (ρ = 0.9932492122) Rejected
last_review has a high cardinality: 1779 distinct values Warning
last_review has 21004 (24.6%) missing values Missing
last_scraped only contains datetime values, but is categorical. Consider applying pd.to_datetime()Type
maximum_nights is highly skewed (γ1 = 229.4506278) Skewed
minimum_nights is highly skewed (γ1 = 31.59665823) Skewed
monthly_price has a high cardinality: 872 distinct values Warning
monthly_price has 80144 (94.0%) missing values Missing
neighbourhood has a high cardinality: 150 distinct values Warning
number_of_reviews has 21003 (24.6%) zeros Zeros
number_of_reviews_ltm has 35468 (41.6%) zeros Zeros
price has a high cardinality: 888 distinct values Warning
review_scores_accuracy has 22734 (26.7%) missing values Missing
review_scores_checkin has 22782 (26.7%) missing values Missing
review_scores_cleanliness has 22721 (26.6%) missing values Missing
review_scores_communication has 22727 (26.7%) missing values Missing
review_scores_location has 22781 (26.7%) missing values Missing
review_scores_rating has 22683 (26.6%) missing values Missing
review_scores_value has 22782 (26.7%) missing values Missing
reviews_per_month has 21004 (24.6%) missing values Missing
security_deposit has a high cardinality: 380 distinct values Warning
security_deposit has 29653 (34.8%) missing values Missing
weekly_price has a high cardinality: 690 distinct values Warning
weekly_price has 78082 (91.6%) missing values Missing

Variables

accommodates
Numeric

Distinct count19
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean3.203407918
Minimum1
Maximum30
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median2
Q34
95-th percentile7
Maximum30
Range29
Interquartile range2

Descriptive statistics

Standard deviation2.024787146
Coef of variation0.6320728417
Kurtosis4.675330574
Mean3.203407918
MAD1.585941834
Skewness1.705369612
Sum273161
Variance4.099762987
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%) 
2 35777 42.0%
 
4 17026 20.0%
 
1 10608 12.4%
 
6 6899 8.1%
 
3 5851 6.9%
 
5 4033 4.7%
 
8 2106 2.5%
 
7 1374 1.6%
 
10 569 0.7%
 
9 448 0.5%
 
Other values (8) 581 0.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 10608 12.4%
 
2 35777 42.0%
 
3 5851 6.9%
 
4 17026 20.0%
 
5 4033 4.7%
 

Maximum 5 values

ValueCountFrequency (%) 
30 1 < 0.1%
 
20 1 < 0.1%
 
16 101 0.1%
 
15 24 < 0.1%
 
14 90 0.1%
 

amenities
Categorical

Distinct count74989
Unique (%)87.9%
Missing (%)< 0.1%
Missing (n)1
{}
 
350
{Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"}
 
71
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron}
 
58
Other values (74985)
84793
ValueCountFrequency (%) 
{} 350 0.4%
 
{Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"} 71 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron} 58 0.1%
 
{Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"} 55 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 54 0.1%
 
{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"} 52 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 45 0.1%
 
{TV,"Cable TV",Wifi,"Air conditioning",Elevator,Heating,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Keypad,"Private living room","Hot water","Bed linens","Long term stays allowed"} 43 0.1%
 
{TV,Wifi,Kitchen,Elevator,"Family/kid friendly",Washer,Essentials,Hangers,"Laptop friendly workspace","Private living room",Microwave,Dishwasher,Oven} 33 < 0.1%
 
{TV,Wifi,Kitchen,Heating,Washer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} 31 < 0.1%
 
Other values (74978) 84480 99.1%
 
Max length1546
Mean length279.3795691
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

availability_30
Numeric

Distinct count32
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean7.662609063
Minimum0
Maximum30
Zeros (%)46.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median2
Q314
95-th percentile29
Maximum30
Range30
Interquartile range14

Descriptive statistics

Standard deviation10.07592017
Coef of variation1.314946396
Kurtosis-0.259285516
Mean7.662609063
MAD8.487324182
Skewness1.080498275
Sum653406
Variance101.5241672
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%) 
0 39823 46.7%
 
30 3646 4.3%
 
29 2778 3.3%
 
1 2718 3.2%
 
2 2136 2.5%
 
3 2116 2.5%
 
4 1981 2.3%
 
5 1957 2.3%
 
14 1865 2.2%
 
6 1851 2.2%
 
Other values (21) 24401 28.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 39823 46.7%
 
1 2718 3.2%
 
2 2136 2.5%
 
3 2116 2.5%
 
4 1981 2.3%
 

Maximum 5 values

ValueCountFrequency (%) 
30 3646 4.3%
 
29 2778 3.3%
 
28 1509 1.8%
 
27 1035 1.2%
 
26 609 0.7%
 

availability_365
Numeric

Distinct count367
Unique (%)0.4%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean118.749613
Minimum0
Maximum365
Zeros (%)33.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median61
Q3252
95-th percentile362
Maximum365
Range365
Interquartile range252

Descriptive statistics

Standard deviation134.7227721
Coef of variation1.134511252
Kurtosis-1.085666103
Mean118.749613
MAD119.0344027
Skewness0.7226800702
Sum10126017
Variance18150.22532
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 28858 33.8%
 
365 2177 2.6%
 
364 1272 1.5%
 
1 845 1.0%
 
89 680 0.8%
 
90 673 0.8%
 
363 625 0.7%
 
257 578 0.7%
 
179 510 0.6%
 
2 498 0.6%
 
Other values (356) 48556 56.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28858 33.8%
 
1 845 1.0%
 
2 498 0.6%
 
3 492 0.6%
 
4 413 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
365 2177 2.6%
 
364 1272 1.5%
 
363 625 0.7%
 
362 348 0.4%
 
361 227 0.3%
 

availability_60
Highly correlated

This variable is highly correlated with availability_30 and should be ignored for analysis

Correlation0.9406128974

availability_90
Highly correlated

This variable is highly correlated with availability_60 and should be ignored for analysis

Correlation0.9777661242

bathrooms
Numeric

Distinct count25
Unique (%)< 0.1%
Missing (%)0.2%
Missing (n)128
Infinite (%)0.0%
Infinite (n)0
Mean1.305655059
Minimum0
Maximum17
Zeros (%)0.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1
Q31.5
95-th percentile2.5
Maximum17
Range17
Interquartile range0.5

Descriptive statistics

Standard deviation0.6147730607
Coef of variation0.4708541176
Kurtosis29.12022176
Mean1.305655059
MAD0.4410566209
Skewness3.553439877
Sum111170
Variance0.3779459162
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%) 
1 59361 69.6%
 
2 12306 14.4%
 
1.5 7879 9.2%
 
2.5 2426 2.8%
 
3 1436 1.7%
 
3.5 554 0.6%
 
0.5 301 0.4%
 
0 299 0.4%
 
4 264 0.3%
 
4.5 114 0.1%
 
Other values (14) 205 0.2%
 
(Missing) 128 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 299 0.4%
 
0.5 301 0.4%
 
1 59361 69.6%
 
1.5 7879 9.2%
 
2 12306 14.4%
 

Maximum 5 values

ValueCountFrequency (%) 
17 1 < 0.1%
 
11 1 < 0.1%
 
10.5 1 < 0.1%
 
10 23 < 0.1%
 
9.5 1 < 0.1%
 

bed_type
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Real Bed
84575
Pull-out Sofa
 
409
Futon
 
180
Other values (2)
 
108
ValueCountFrequency (%) 
Real Bed 84575 99.2%
 
Pull-out Sofa 409 0.5%
 
Futon 180 0.2%
 
Couch 66 0.1%
 
Airbed 42 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length13
Mean length8.014283536
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

bedrooms
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.1%
Missing (n)43
Infinite (%)0.0%
Infinite (n)0
Mean1.417458641
Minimum0
Maximum22
Zeros (%)6.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q32
95-th percentile3
Maximum22
Range22
Interquartile range1

Descriptive statistics

Standard deviation0.9227060843
Coef of variation0.6509580297
Kurtosis8.915098104
Mean1.417458641
MAD0.6927195819
Skewness1.962186823
Sum120810
Variance0.851386518
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%) 
1 53248 62.4%
 
2 17616 20.7%
 
3 5952 7.0%
 
0 5144 6.0%
 
4 2289 2.7%
 
5 722 0.8%
 
6 182 0.2%
 
7 49 0.1%
 
8 12 < 0.1%
 
10 6 < 0.1%
 
Other values (5) 10 < 0.1%
 
(Missing) 43 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5144 6.0%
 
1 53248 62.4%
 
2 17616 20.7%
 
3 5952 7.0%
 
4 2289 2.7%
 

Maximum 5 values

ValueCountFrequency (%) 
22 1 < 0.1%
 
16 1 < 0.1%
 
12 1 < 0.1%
 
11 2 < 0.1%
 
10 6 < 0.1%
 

beds
Numeric

Distinct count23
Unique (%)< 0.1%
Missing (%)0.2%
Missing (n)154
Infinite (%)0.0%
Infinite (n)0
Mean1.755894689
Minimum0
Maximum28
Zeros (%)2.5%
Mini histogram

Quantile statistics

Minimum0
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum28
Range28
Interquartile range1

Descriptive statistics

Standard deviation1.278717353
Coef of variation0.7282426227
Kurtosis16.20577142
Mean1.755894689
MAD0.911683207
Skewness2.798381894
Sum149460
Variance1.63511807
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%) 
1 46476 54.5%
 
2 20662 24.2%
 
3 8667 10.2%
 
4 3998 4.7%
 
0 2090 2.5%
 
5 1623 1.9%
 
6 842 1.0%
 
7 325 0.4%
 
8 201 0.2%
 
10 75 0.1%
 
Other values (12) 160 0.2%
 
(Missing) 154 0.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2090 2.5%
 
1 46476 54.5%
 
2 20662 24.2%
 
3 8667 10.2%
 
4 3998 4.7%
 

Maximum 5 values

ValueCountFrequency (%) 
28 1 < 0.1%
 
20 3 < 0.1%
 
19 2 < 0.1%
 
18 2 < 0.1%
 
17 2 < 0.1%
 

calculated_host_listings_count
Numeric

Distinct count86
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean24.93245145
Minimum1
Maximum1130
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q35
95-th percentile65
Maximum1130
Range1129
Interquartile range4

Descriptive statistics

Standard deviation131.0934511
Coef of variation5.257944706
Kurtosis63.96747936
Mean24.93245145
MAD38.95463532
Skewness7.971575249
Sum2126040
Variance17185.49292
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 43850 51.4%
 
2 12034 14.1%
 
3 4968 5.8%
 
4 2924 3.4%
 
5 1795 2.1%
 
6 1422 1.7%
 
7 1148 1.3%
 
1130 1130 1.3%
 
8 832 1.0%
 
9 729 0.9%
 
Other values (75) 14440 16.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 43850 51.4%
 
2 12034 14.1%
 
3 4968 5.8%
 
4 2924 3.4%
 
5 1795 2.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1130 1130 1.3%
 
227 227 0.3%
 
220 220 0.3%
 
196 196 0.2%
 
189 189 0.2%
 

calculated_host_listings_count_entire_homes
Highly correlated

This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis

Correlation0.9960387541

calculated_host_listings_count_private_rooms
Numeric

Distinct count38
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean1.915963036
Minimum0
Maximum135
Zeros (%)48.4%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q31
95-th percentile6
Maximum135
Range135
Interquartile range1

Descriptive statistics

Standard deviation7.988859935
Coef of variation4.169631556
Kurtosis167.7368941
Mean1.915963036
MAD2.412308529
Skewness11.81047617
Sum163378
Variance63.82188307
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%) 
0 41260 48.4%
 
1 25982 30.5%
 
2 6968 8.2%
 
3 3836 4.5%
 
4 1429 1.7%
 
5 1263 1.5%
 
6 600 0.7%
 
7 563 0.7%
 
10 358 0.4%
 
8 305 0.4%
 
Other values (27) 2708 3.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 41260 48.4%
 
1 25982 30.5%
 
2 6968 8.2%
 
3 3836 4.5%
 
4 1429 1.7%
 

Maximum 5 values

ValueCountFrequency (%) 
135 144 0.2%
 
96 101 0.1%
 
89 93 0.1%
 
41 73 0.1%
 
39 91 0.1%
 

calculated_host_listings_count_shared_rooms
Numeric

Distinct count14
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean0.04647481002
Minimum0
Maximum18
Zeros (%)98.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum18
Range18
Interquartile range0

Descriptive statistics

Standard deviation0.6879514535
Coef of variation14.80267382
Kurtosis436.3144454
Mean0.04647481002
MAD0.0918323323
Skewness19.93070147
Sum3963
Variance0.4732772024
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%) 
0 84247 98.8%
 
1 664 0.8%
 
12 56 0.1%
 
17 53 0.1%
 
2 45 0.1%
 
8 38 < 0.1%
 
7 36 < 0.1%
 
9 32 < 0.1%
 
4 25 < 0.1%
 
3 24 < 0.1%
 
Other values (3) 52 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 84247 98.8%
 
1 664 0.8%
 
2 45 0.1%
 
3 24 < 0.1%
 
4 25 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
18 22 < 0.1%
 
17 53 0.1%
 
12 56 0.1%
 
10 11 < 0.1%
 
9 32 < 0.1%
 

cancellation_policy
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
strict_14_with_grace_period
36612
flexible
27738
moderate
20052
Other values (5)
 
870
ValueCountFrequency (%) 
strict_14_with_grace_period 36612 42.9%
 
flexible 27738 32.5%
 
moderate 20052 23.5%
 
super_strict_60 473 0.6%
 
super_strict_30 366 0.4%
 
luxury_moderate 20 < 0.1%
 
strict 8 < 0.1%
 
luxury_super_strict_95 3 < 0.1%
 
(Missing) 1 < 0.1%
 
Max length27
Mean length16.22841931
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

cleaning_fee
Categorical

Distinct count259
Unique (%)0.3%
Missing (%)25.2%
Missing (n)21530
$0.00
 
5938
$20.00
 
5240
$30.00
 
5104
Other values (255)
47461
(Missing)
21530
ValueCountFrequency (%) 
$0.00 5938 7.0%
 
$20.00 5240 6.1%
 
$30.00 5104 6.0%
 
$10.00 4549 5.3%
 
$50.00 3880 4.6%
 
$15.00 3689 4.3%
 
$40.00 3677 4.3%
 
$25.00 3271 3.8%
 
$60.00 2506 2.9%
 
$35.00 1961 2.3%
 
Other values (248) 23928 28.1%
 
(Missing) 21530 25.2%
 
Max length9
Mean length5.198315997
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

df_index
Numeric

Distinct count85273
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean42636.95077
Minimum0
Maximum85273
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile4264.6
Q121319
Median42637
Q363955
95-th percentile81009.4
Maximum85273
Range85273
Interquartile range42636

Descriptive statistics

Standard deviation24616.42016
Coef of variation0.577349452
Kurtosis-1.19998789
Mean42636.95077
MAD21318.29923
Skewness-1.028584916e-05
Sum3635780703
Variance605968141.6
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 85273.], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
27288 1 < 0.1%
 
31386 1 < 0.1%
 
29339 1 < 0.1%
 
19100 1 < 0.1%
 
17053 1 < 0.1%
 
23198 1 < 0.1%
 
21151 1 < 0.1%
 
76464 1 < 0.1%
 
74417 1 < 0.1%
 
Other values (85263) 85263 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
85273 1 < 0.1%
 
85272 1 < 0.1%
 
85271 1 < 0.1%
 
85270 1 < 0.1%
 
85269 1 < 0.1%
 

experiences_offered
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
none
83540
business
 
598
family
 
493
Other values (2)
 
642
ValueCountFrequency (%) 
none 83540 98.0%
 
business 598 0.7%
 
family 493 0.6%
 
social 426 0.5%
 
romantic 216 0.3%
 
Max length8
Mean length4.059737549
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

extra_people
Categorical

Distinct count114
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
$0.00
52172
$10.00
 
7915
$15.00
 
6516
Other values (110)
18669
ValueCountFrequency (%) 
$0.00 52172 61.2%
 
$10.00 7915 9.3%
 
$15.00 6516 7.6%
 
$20.00 4851 5.7%
 
$25.00 2285 2.7%
 
$5.00 2270 2.7%
 
$30.00 1698 2.0%
 
$50.00 1072 1.3%
 
$12.00 662 0.8%
 
$35.00 641 0.8%
 
Other values (103) 5190 6.1%
 
Max length7
Mean length5.344857106
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

first_review
Categorical

Distinct count2759
Unique (%)3.2%
Missing (%)24.6%
Missing (n)21004
2019-07-07
 
234
2019-01-01
 
222
2019-07-14
 
199
Other values (2755)
63614
(Missing)
21004
ValueCountFrequency (%) 
2019-07-07 234 0.3%
 
2019-01-01 222 0.3%
 
2019-07-14 199 0.2%
 
2019-06-30 196 0.2%
 
2019-06-02 185 0.2%
 
2019-08-11 176 0.2%
 
2019-01-02 170 0.2%
 
2019-08-04 162 0.2%
 
2019-04-28 162 0.2%
 
2019-06-16 161 0.2%
 
Other values (2748) 62402 73.2%
 
(Missing) 21004 24.6%
 
Max length10
Mean length8.275796559
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

guests_included
Numeric

Distinct count17
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean1.615113988
Minimum1
Maximum16
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum16
Range15
Interquartile range1

Descriptive statistics

Standard deviation1.35578889
Coef of variation0.8394385166
Kurtosis15.30447086
Mean1.615113988
MAD0.8885653094
Skewness3.30669013
Sum137724
Variance1.838163515
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%) 
1 61590 72.2%
 
2 12953 15.2%
 
4 5594 6.6%
 
3 1622 1.9%
 
6 1595 1.9%
 
5 874 1.0%
 
8 469 0.5%
 
7 251 0.3%
 
10 138 0.2%
 
9 74 0.1%
 
Other values (6) 112 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 61590 72.2%
 
2 12953 15.2%
 
3 1622 1.9%
 
4 5594 6.6%
 
5 874 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
16 30 < 0.1%
 
15 12 < 0.1%
 
14 6 < 0.1%
 
13 5 < 0.1%
 
12 33 < 0.1%
 

host_has_profile_pic
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)17
t
85026
f
 
230
(Missing)
 
17
ValueCountFrequency (%) 
t 85026 99.7%
 
f 230 0.3%
 
(Missing) 17 < 0.1%
 

host_identity_verified
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)17
f
54698
t
30558
(Missing)
 
17
ValueCountFrequency (%) 
f 54698 64.1%
 
t 30558 35.8%
 
(Missing) 17 < 0.1%
 

host_is_superhost
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)17
f
72741
t
 
12515
(Missing)
 
17
ValueCountFrequency (%) 
f 72741 85.3%
 
t 12515 14.7%
 
(Missing) 17 < 0.1%
 

host_since
Categorical

Distinct count3418
Unique (%)4.0%
Missing (%)< 0.1%
Missing (n)16
2015-05-21
 
1164
2017-10-25
 
297
2015-03-05
 
266
Other values (3414)
83530
ValueCountFrequency (%) 
2015-05-21 1164 1.4%
 
2017-10-25 297 0.3%
 
2015-03-05 266 0.3%
 
2017-06-26 264 0.3%
 
2015-11-04 251 0.3%
 
2018-11-08 202 0.2%
 
2011-11-22 177 0.2%
 
2012-03-18 168 0.2%
 
2014-03-26 167 0.2%
 
2015-02-11 160 0.2%
 
Other values (3407) 82141 96.3%
 
Max length10
Mean length9.998686571
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

host_verifications
Categorical

Distinct count548
Unique (%)0.6%
Missing (%)< 0.1%
Missing (n)1
['email', 'phone', 'reviews', 'jumio', 'government_id']
 
9938
['email', 'phone']
 
8952
['email', 'phone', 'reviews']
 
6623
Other values (544)
59759
ValueCountFrequency (%) 
['email', 'phone', 'reviews', 'jumio', 'government_id'] 9938 11.7%
 
['email', 'phone'] 8952 10.5%
 
['email', 'phone', 'reviews'] 6623 7.8%
 
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] 6250 7.3%
 
['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id'] 5077 6.0%
 
['email', 'phone', 'reviews', 'jumio', 'government_id', 'work_email'] 3384 4.0%
 
['email', 'phone', 'facebook', 'reviews', 'jumio', 'government_id'] 3347 3.9%
 
['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] 2823 3.3%
 
['email', 'phone', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual'] 2741 3.2%
 
['phone'] 2460 2.9%
 
Other values (537) 33677 39.5%
 
Max length170
Mean length66.24462608
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

id
Highly correlated

This variable is highly correlated with df_index and should be ignored for analysis

Correlation0.9932492122

instant_bookable
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
f
48092
t
37180
(Missing)
 
1
ValueCountFrequency (%) 
f 48092 56.4%
 
t 37180 43.6%
 
(Missing) 1 < 0.1%
 

is_location_exact
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
t
52899
f
32373
(Missing)
 
1
ValueCountFrequency (%) 
t 52899 62.0%
 
f 32373 38.0%
 
(Missing) 1 < 0.1%
 

last_review
Categorical

Distinct count1779
Unique (%)2.1%
Missing (%)24.6%
Missing (n)21004
2019-08-26
 
1312
2019-09-01
 
1258
2019-09-08
 
1148
Other values (1775)
60551
(Missing)
21004
ValueCountFrequency (%) 
2019-08-26 1312 1.5%
 
2019-09-01 1258 1.5%
 
2019-09-08 1148 1.3%
 
2019-08-25 1137 1.3%
 
2019-08-27 1086 1.3%
 
2019-08-31 1070 1.3%
 
2019-08-30 969 1.1%
 
2019-08-18 954 1.1%
 
2019-09-12 849 1.0%
 
2019-08-28 780 0.9%
 
Other values (1768) 53706 63.0%
 
(Missing) 21004 24.6%
 
Max length10
Mean length8.275796559
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

last_scraped
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
2019-09-15
66578
2019-09-14
18692
2019-09-30
 
3
ValueCountFrequency (%) 
2019-09-15 66578 78.1%
 
2019-09-14 18692 21.9%
 
2019-09-30 3 < 0.1%
 
Max length10
Mean length10
Min length10
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

latitude
Numeric

Distinct count20695
Unique (%)24.3%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean51.50971696
Minimum51.29479
Maximum51.68169
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum51.29479
5-th percentile51.4253
Q151.48551
Median51.51403
Q351.53747
95-th percentile51.58418
Maximum51.68169
Range0.3869
Interquartile range0.05196

Descriptive statistics

Standard deviation0.0462845385
Coef of variation0.0008985593637
Kurtosis0.9700292581
Mean51.50971696
MAD0.0350742059
Skewness-0.3263567874
Sum4392336.585
Variance0.002142258504
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
51.51571 27 < 0.1%
 
51.51375 24 < 0.1%
 
51.52559 23 < 0.1%
 
51.52476 22 < 0.1%
 
51.51382 22 < 0.1%
 
51.49133 21 < 0.1%
 
51.5129 21 < 0.1%
 
51.51307 21 < 0.1%
 
51.51343 21 < 0.1%
 
51.5141 21 < 0.1%
 
Other values (20684) 85049 99.7%
 

Minimum 5 values

ValueCountFrequency (%) 
51.29479 1 < 0.1%
 
51.29733 1 < 0.1%
 
51.29893 1 < 0.1%
 
51.29911 1 < 0.1%
 
51.29914 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
51.68169 1 < 0.1%
 
51.6792 1 < 0.1%
 
51.67651 1 < 0.1%
 
51.67566 1 < 0.1%
 
51.67501 1 < 0.1%
 

longitude
Numeric

Distinct count32024
Unique (%)37.6%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean-0.1279442907
Minimum-0.50916
Maximum0.28774
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-0.50916
5-th percentile-0.28205
Q1-0.1879925
Median-0.12592
Q3-0.0699875
95-th percentile0.01455
Maximum0.28774
Range0.7969
Interquartile range0.118005

Descriptive statistics

Standard deviation0.09237933599
Coef of variation-0.7220278096
Kurtosis1.215919743
Mean-0.1279442907
MAD0.07100705557
Skewness-0.1181528542
Sum-10910.06556
Variance0.008533941718
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
-0.07057 14 < 0.1%
 
-0.09728 13 < 0.1%
 
-0.0718 13 < 0.1%
 
-0.13649 13 < 0.1%
 
-0.19517 13 < 0.1%
 
-0.13745 13 < 0.1%
 
-0.14027 12 < 0.1%
 
-0.13472 12 < 0.1%
 
-0.10878 12 < 0.1%
 
-0.1404 12 < 0.1%
 
Other values (32013) 85145 99.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-0.50916 1 < 0.1%
 
-0.5013 1 < 0.1%
 
-0.49625 1 < 0.1%
 
-0.49582 1 < 0.1%
 
-0.48786 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
0.28774 1 < 0.1%
 
0.28539 1 < 0.1%
 
0.28429 1 < 0.1%
 
0.27268 1 < 0.1%
 
0.27208 1 < 0.1%
 

maximum_nights
Numeric

Distinct count311
Unique (%)0.4%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean20127.72094
Minimum1
Maximum999999999
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile7
Q131
Median1125
Q31125
95-th percentile1125
Maximum999999999
Range999999998
Interquartile range1094

Descriptive statistics

Standard deviation3883047.211
Coef of variation192.9203621
Kurtosis55498.88658
Mean20127.72094
MAD38812.75849
Skewness229.4506278
Sum1716331020
Variance1.507805565e+13
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1125 50694 59.4%
 
30 4580 5.4%
 
14 3115 3.7%
 
7 2389 2.8%
 
90 2336 2.7%
 
365 1629 1.9%
 
60 1503 1.8%
 
10 1398 1.6%
 
21 1211 1.4%
 
1124 1142 1.3%
 
Other values (300) 15275 17.9%
 

Minimum 5 values

ValueCountFrequency (%) 
1 149 0.2%
 
2 313 0.4%
 
3 576 0.7%
 
4 617 0.7%
 
5 918 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
999999999 1 < 0.1%
 
524855552 1 < 0.1%
 
99999999 1 < 0.1%
 
10000000 1 < 0.1%
 
9999999 1 < 0.1%
 

minimum_nights
Numeric

Distinct count110
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean4.120402946
Minimum1
Maximum1125
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median2
Q33
95-th percentile7
Maximum1125
Range1124
Interquartile range2

Descriptive statistics

Standard deviation15.65286387
Coef of variation3.798867266
Kurtosis1754.601583
Mean4.120402946
MAD3.728571011
Skewness31.59665823
Sum351355
Variance245.0121474
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 28511 33.4%
 
2 25480 29.9%
 
3 13779 16.2%
 
4 4482 5.3%
 
5 4334 5.1%
 
7 3525 4.1%
 
6 1041 1.2%
 
14 804 0.9%
 
10 535 0.6%
 
30 490 0.6%
 
Other values (99) 2291 2.7%
 

Minimum 5 values

ValueCountFrequency (%) 
1 28511 33.4%
 
2 25480 29.9%
 
3 13779 16.2%
 
4 4482 5.3%
 
5 4334 5.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1125 1 < 0.1%
 
1124 2 < 0.1%
 
1000 2 < 0.1%
 
999 1 < 0.1%
 
900 1 < 0.1%
 

monthly_price
Categorical

Distinct count872
Unique (%)1.0%
Missing (%)94.0%
Missing (n)80144
$2,000.00
 
166
$1,000.00
 
157
$1,200.00
 
154
Other values (868)
 
4652
(Missing)
80144
ValueCountFrequency (%) 
$2,000.00 166 0.2%
 
$1,000.00 157 0.2%
 
$1,200.00 154 0.2%
 
$800.00 138 0.2%
 
$1,500.00 137 0.2%
 
$900.00 127 0.1%
 
$2,500.00 123 0.1%
 
$3,000.00 116 0.1%
 
$1,400.00 105 0.1%
 
$1,800.00 104 0.1%
 
Other values (861) 3802 4.5%
 
(Missing) 80144 94.0%
 
Max length10
Mean length3.327313452
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

neighbourhood
Categorical

Distinct count150
Unique (%)0.2%
Missing (%)< 0.1%
Missing (n)1
City of Westminster
 
5583
LB of Tower Hamlets
 
4609
LB of Hackney
 
3788
Other values (146)
71292
ValueCountFrequency (%) 
City of Westminster 5583 6.5%
 
LB of Tower Hamlets 4609 5.4%
 
LB of Hackney 3788 4.4%
 
LB of Islington 3767 4.4%
 
LB of Camden 3096 3.6%
 
LB of Southwark 2562 3.0%
 
LB of Wandsworth 2556 3.0%
 
RB of Kensington and Chelsea 2516 3.0%
 
LB of Brent 2497 2.9%
 
LB of Lambeth 2455 2.9%
 
Other values (139) 51843 60.8%
 
Max length28
Mean length14.04991029
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

neighbourhood_cleansed
Categorical

Distinct count34
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Westminster
 
9809
Tower Hamlets
 
8198
Hackney
 
6240
Other values (30)
61025
ValueCountFrequency (%) 
Westminster 9809 11.5%
 
Tower Hamlets 8198 9.6%
 
Hackney 6240 7.3%
 
Kensington and Chelsea 6023 7.1%
 
Camden 5962 7.0%
 
Islington 5131 6.0%
 
Southwark 4888 5.7%
 
Lambeth 4856 5.7%
 
Wandsworth 4353 5.1%
 
Hammersmith and Fulham 4190 4.9%
 
Other values (23) 25622 30.0%
 
Max length22
Mean length10.62498094
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

number_of_reviews
Numeric

Distinct count412
Unique (%)0.5%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean16.81730228
Minimum0
Maximum690
Zeros (%)24.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median4
Q317
95-th percentile77
Maximum690
Range690
Interquartile range16

Descriptive statistics

Standard deviation35.67412186
Coef of variation2.121274939
Kurtosis38.66970663
Mean16.81730228
MAD19.77222867
Skewness5.033409711
Sum1434045
Variance1272.642971
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 21003 24.6%
 
1 9291 10.9%
 
2 5929 7.0%
 
3 4538 5.3%
 
4 3622 4.2%
 
5 2873 3.4%
 
6 2480 2.9%
 
7 2087 2.4%
 
8 1914 2.2%
 
9 1698 2.0%
 
Other values (401) 29837 35.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 21003 24.6%
 
1 9291 10.9%
 
2 5929 7.0%
 
3 4538 5.3%
 
4 3622 4.2%
 

Maximum 5 values

ValueCountFrequency (%) 
690 1 < 0.1%
 
633 1 < 0.1%
 
612 1 < 0.1%
 
595 1 < 0.1%
 
591 1 < 0.1%
 

number_of_reviews_ltm
Numeric

Distinct count147
Unique (%)0.2%
Missing (%)< 0.1%
Missing (n)1
Infinite (%)0.0%
Infinite (n)0
Mean6.613519092
Minimum0
Maximum231
Zeros (%)41.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q38
95-th percentile31
Maximum231
Range231
Interquartile range8

Descriptive statistics

Standard deviation12.70142361
Coef of variation1.920524222
Kurtosis20.65124055
Mean6.613519092
MAD7.886865158
Skewness3.753960323
Sum563948
Variance161.3261617
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0 35468 41.6%
 
1 8370 9.8%
 
2 5441 6.4%
 
3 4130 4.8%
 
4 3380 4.0%
 
5 2745 3.2%
 
6 2318 2.7%
 
7 2023 2.4%
 
8 1737 2.0%
 
9 1584 1.9%
 
Other values (136) 18076 21.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 35468 41.6%
 
1 8370 9.8%
 
2 5441 6.4%
 
3 4130 4.8%
 
4 3380 4.0%
 

Maximum 5 values

ValueCountFrequency (%) 
231 1 < 0.1%
 
200 1 < 0.1%
 
185 1 < 0.1%
 
182 1 < 0.1%
 
180 1 < 0.1%
 

price
Categorical

Distinct count888
Unique (%)1.0%
Missing (%)< 0.1%
Missing (n)1
$50.00
 
3107
$100.00
 
3066
$40.00
 
2796
Other values (884)
76303
ValueCountFrequency (%) 
$50.00 3107 3.6%
 
$100.00 3066 3.6%
 
$40.00 2796 3.3%
 
$35.00 2531 3.0%
 
$30.00 2365 2.8%
 
$120.00 2360 2.8%
 
$45.00 2303 2.7%
 
$150.00 2280 2.7%
 
$60.00 2245 2.6%
 
$80.00 2226 2.6%
 
Other values (877) 59993 70.4%
 
Max length10
Mean length6.420566885
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

property_type
Categorical

Distinct count44
Unique (%)0.1%
Missing (%)< 0.1%
Missing (n)1
Apartment
56401
House
17952
Townhouse
 
2995
Other values (40)
 
7924
ValueCountFrequency (%) 
Apartment 56401 66.1%
 
House 17952 21.1%
 
Townhouse 2995 3.5%
 
Condominium 2716 3.2%
 
Serviced apartment 1719 2.0%
 
Loft 739 0.9%
 
Bed and breakfast 647 0.8%
 
Guest suite 364 0.4%
 
Guesthouse 305 0.4%
 
Boutique hotel 242 0.3%
 
Other values (33) 1192 1.4%
 
Max length29
Mean length8.412592497
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

require_guest_phone_verification
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
f
83843
t
 
1429
(Missing)
 
1
ValueCountFrequency (%) 
f 83843 98.3%
 
t 1429 1.7%
 
(Missing) 1 < 0.1%
 

require_guest_profile_picture
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
f
84413
t
 
859
(Missing)
 
1
ValueCountFrequency (%) 
f 84413 99.0%
 
t 859 1.0%
 
(Missing) 1 < 0.1%
 

requires_license
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
f
85269
t
 
3
(Missing)
 
1
ValueCountFrequency (%) 
f 85269 > 99.9%
 
t 3 < 0.1%
 
(Missing) 1 < 0.1%
 

review_scores_accuracy
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22734
Infinite (%)0.0%
Infinite (n)0
Mean9.500311805
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation0.9994301354
Coef of variation0.1051997193
Kurtosis19.01700441
Mean9.500311805
MAD0.6788645128
Skewness-3.648096413
Sum594140
Variance0.9988605955
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 42482 49.8%
 
9 14163 16.6%
 
8 3716 4.4%
 
7 802 0.9%
 
6 761 0.9%
 
2 305 0.4%
 
4 189 0.2%
 
5 108 0.1%
 
3 13 < 0.1%
 
(Missing) 22734 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 305 0.4%
 
3 13 < 0.1%
 
4 189 0.2%
 
5 108 0.1%
 
6 761 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
10 42482 49.8%
 
9 14163 16.6%
 
8 3716 4.4%
 
7 802 0.9%
 
6 761 0.9%
 

review_scores_checkin
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22782
Infinite (%)0.0%
Infinite (n)0
Mean9.624041862
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q110
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.9068226974
Coef of variation0.09422472495
Kurtosis26.23327385
Mean9.624041862
MAD0.5711897319
Skewness-4.336635281
Sum601416
Variance0.8223274045
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 47471 55.7%
 
9 10728 12.6%
 
8 2616 3.1%
 
7 616 0.7%
 
6 570 0.7%
 
2 263 0.3%
 
4 147 0.2%
 
5 70 0.1%
 
3 10 < 0.1%
 
(Missing) 22782 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 263 0.3%
 
3 10 < 0.1%
 
4 147 0.2%
 
5 70 0.1%
 
6 570 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
10 47471 55.7%
 
9 10728 12.6%
 
8 2616 3.1%
 
7 616 0.7%
 
6 570 0.7%
 

review_scores_cleanliness
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.6%
Missing (n)22721
Infinite (%)0.0%
Infinite (n)0
Mean9.261494437
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile7
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation1.149805624
Coef of variation0.1241490379
Kurtosis10.79236777
Mean9.261494437
MAD0.8176075469
Skewness-2.714264208
Sum579325
Variance1.322052973
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 34626 40.6%
 
9 17642 20.7%
 
8 6598 7.7%
 
7 1669 2.0%
 
6 1138 1.3%
 
2 349 0.4%
 
4 310 0.4%
 
5 197 0.2%
 
3 23 < 0.1%
 
(Missing) 22721 26.6%
 

Minimum 5 values

ValueCountFrequency (%) 
2 349 0.4%
 
3 23 < 0.1%
 
4 310 0.4%
 
5 197 0.2%
 
6 1138 1.3%
 

Maximum 5 values

ValueCountFrequency (%) 
10 34626 40.6%
 
9 17642 20.7%
 
8 6598 7.7%
 
7 1669 2.0%
 
6 1138 1.3%
 

review_scores_communication
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22727
Infinite (%)0.0%
Infinite (n)0
Mean9.64827487
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q110
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range0

Descriptive statistics

Standard deviation0.9056841568
Coef of variation0.09387006164
Kurtosis27.68830452
Mean9.64827487
MAD0.5499522087
Skewness-4.519780247
Sum603461
Variance0.8202637918
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 48898 57.3%
 
9 9561 11.2%
 
8 2414 2.8%
 
7 588 0.7%
 
6 568 0.7%
 
2 269 0.3%
 
4 156 0.2%
 
5 79 0.1%
 
3 13 < 0.1%
 
(Missing) 22727 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 269 0.3%
 
3 13 < 0.1%
 
4 156 0.2%
 
5 79 0.1%
 
6 568 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
10 48898 57.3%
 
9 9561 11.2%
 
8 2414 2.8%
 
7 588 0.7%
 
6 568 0.7%
 

review_scores_location
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22781
Infinite (%)0.0%
Infinite (n)0
Mean9.526899443
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation0.830363656
Coef of variation0.08715990558
Kurtosis19.62898166
Mean9.526899443
MAD0.6150791756
Skewness-3.34135892
Sum595355
Variance0.6895038011
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 40623 47.6%
 
9 16972 19.9%
 
8 3649 4.3%
 
6 526 0.6%
 
7 466 0.5%
 
2 142 0.2%
 
4 85 0.1%
 
5 28 < 0.1%
 
3 1 < 0.1%
 
(Missing) 22781 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 142 0.2%
 
3 1 < 0.1%
 
4 85 0.1%
 
5 28 < 0.1%
 
6 526 0.6%
 

Maximum 5 values

ValueCountFrequency (%) 
10 40623 47.6%
 
9 16972 19.9%
 
8 3649 4.3%
 
7 466 0.5%
 
6 526 0.6%
 

review_scores_rating
Numeric

Distinct count62
Unique (%)0.1%
Missing (%)26.6%
Missing (n)22683
Infinite (%)0.0%
Infinite (n)0
Mean92.51442722
Minimum20
Maximum100
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20
5-th percentile76
Q190
Median96
Q3100
95-th percentile100
Maximum100
Range80
Interquartile range10

Descriptive statistics

Standard deviation10.25770956
Coef of variation0.1108768639
Kurtosis14.52539377
Mean92.51442722
MAD6.857333534
Skewness-3.098447603
Sum5790478
Variance105.2206054
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
100 17907 21.0%
 
98 3877 4.5%
 
97 3731 4.4%
 
96 3640 4.3%
 
93 3623 4.2%
 
90 3364 3.9%
 
95 3343 3.9%
 
80 3303 3.9%
 
99 2505 2.9%
 
94 2390 2.8%
 
Other values (51) 14907 17.5%
 
(Missing) 22683 26.6%
 

Minimum 5 values

ValueCountFrequency (%) 
20 295 0.3%
 
30 9 < 0.1%
 
32 1 < 0.1%
 
33 1 < 0.1%
 
40 223 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
100 17907 21.0%
 
99 2505 2.9%
 
98 3877 4.5%
 
97 3731 4.4%
 
96 3640 4.3%
 

review_scores_value
Numeric

Distinct count10
Unique (%)< 0.1%
Missing (%)26.7%
Missing (n)22782
Infinite (%)0.0%
Infinite (n)0
Mean9.26541422
Minimum2
Maximum10
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile8
Q19
Median10
Q310
95-th percentile10
Maximum10
Range8
Interquartile range1

Descriptive statistics

Standard deviation1.04789939
Coef of variation0.1130979538
Kurtosis13.0989518
Mean9.26541422
MAD0.7395581729
Skewness-2.846842154
Sum579005
Variance1.098093131
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
10 31457 36.9%
 
9 22279 26.1%
 
8 6050 7.1%
 
7 1101 1.3%
 
6 929 1.1%
 
2 288 0.3%
 
4 234 0.3%
 
5 136 0.2%
 
3 17 < 0.1%
 
(Missing) 22782 26.7%
 

Minimum 5 values

ValueCountFrequency (%) 
2 288 0.3%
 
3 17 < 0.1%
 
4 234 0.3%
 
5 136 0.2%
 
6 929 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
10 31457 36.9%
 
9 22279 26.1%
 
8 6050 7.1%
 
7 1101 1.3%
 
6 929 1.1%
 

reviews_per_month
Numeric

Distinct count932
Unique (%)1.1%
Missing (%)24.6%
Missing (n)21004
Infinite (%)0.0%
Infinite (n)0
Mean1.178750253
Minimum0.01
Maximum48.21
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.01
5-th percentile0.05
Q10.24
Median0.74
Q31.6
95-th percentile3.94
Maximum48.21
Range48.2
Interquartile range1.36

Descriptive statistics

Standard deviation1.375763779
Coef of variation1.167137632
Kurtosis30.11427919
Mean1.178750253
MAD0.9649094663
Skewness2.981539061
Sum75757.1
Variance1.892725976
Memory size666.3 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1 1889 2.2%
 
0.04 1066 1.3%
 
0.08 1022 1.2%
 
0.05 954 1.1%
 
0.07 923 1.1%
 
0.02 921 1.1%
 
0.03 896 1.1%
 
0.12 803 0.9%
 
0.06 800 0.9%
 
0.1 714 0.8%
 
Other values (921) 54281 63.7%
 
(Missing) 21004 24.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0.01 34 < 0.1%
 
0.02 921 1.1%
 
0.03 896 1.1%
 
0.04 1066 1.3%
 
0.05 954 1.1%
 

Maximum 5 values

ValueCountFrequency (%) 
48.21 1 < 0.1%
 
24.39 1 < 0.1%
 
15.52 1 < 0.1%
 
15.17 1 < 0.1%
 
14.72 1 < 0.1%
 

room_type
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)1
Entire home/apt
47115
Private room
36013
Hotel room
 
1510
ValueCountFrequency (%) 
Entire home/apt 47115 55.3%
 
Private room 36013 42.2%
 
Hotel room 1510 1.8%
 
Shared room 634 0.7%
 
(Missing) 1 < 0.1%
 
Max length15
Mean length13.61460251
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

security_deposit
Categorical

Distinct count380
Unique (%)0.4%
Missing (%)34.8%
Missing (n)29653
$0.00
19620
$100.00
6014
$200.00
 
4997
Other values (376)
24989
(Missing)
29653
ValueCountFrequency (%) 
$0.00 19620 23.0%
 
$100.00 6014 7.1%
 
$200.00 4997 5.9%
 
$250.00 3644 4.3%
 
$300.00 3322 3.9%
 
$500.00 3283 3.8%
 
$150.00 2904 3.4%
 
$85.00 1958 2.3%
 
$495.00 1324 1.6%
 
$350.00 1017 1.2%
 
Other values (369) 7537 8.8%
 
(Missing) 29653 34.8%
 
Max length10
Mean length5.137992096
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

weekly_price
Categorical

Distinct count690
Unique (%)0.8%
Missing (%)91.6%
Missing (n)78082
$300.00
 
295
$500.00
 
277
$250.00
 
255
Other values (686)
 
6364
(Missing)
78082
ValueCountFrequency (%) 
$300.00 295 0.3%
 
$500.00 277 0.3%
 
$250.00 255 0.3%
 
$350.00 251 0.3%
 
$600.00 248 0.3%
 
$200.00 231 0.3%
 
$400.00 212 0.2%
 
$700.00 182 0.2%
 
$450.00 181 0.2%
 
$550.00 147 0.2%
 
Other values (679) 4912 5.8%
 
(Missing) 78082 91.6%
 
Max length9
Mean length3.357510584
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Correlations

Missing values

Sample

First rows

accommodatesamenitiesavailability_30availability_365availability_60availability_90bathroomsbed_typebedroomsbedscalculated_host_listings_countcalculated_host_listings_count_entire_homescalculated_host_listings_count_private_roomscalculated_host_listings_count_shared_roomscancellation_policycleaning_feedf_indexexperiences_offeredextra_peoplefirst_reviewguests_includedhost_has_profile_pichost_identity_verifiedhost_is_superhosthost_sincehost_verificationsidinstant_bookableis_location_exactlast_reviewlast_scrapedlatitudelongitudemaximum_nightsminimum_nightsmonthly_priceneighbourhoodneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typerequire_guest_phone_verificationrequire_guest_profile_picturerequires_licensereview_scores_accuracyreview_scores_checkinreview_scores_cleanlinessreview_scores_communicationreview_scores_locationreview_scores_ratingreview_scores_valuereviews_per_monthroom_typesecurity_depositweekly_price
04.0{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Pack ’n Play/travel crib","Hot water","Long term stays allowed"}19.0344.042.072.01.0Real Bed1.01.02.02.00.00.0strict_14_with_grace_period$30.000family$20.002010-03-212.0ttt2009-10-03['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']11551.0tt2019-07-102019-09-1551.46225-0.11732180.02.0$2,350.00BrixtonLambeth184.01.0$88.00Apartmenttff9.010.09.010.09.092.09.01.59Entire home/apt$400.00$645.00
12.0{TV,"Cable TV",Wifi,Kitchen,"Paid parking off premises","Smoking allowed","Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"Children’s books and toys","Babysitter recommendations",Crib,"Pack ’n Play/travel crib","Room-darkening shades","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection","Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","No stairs or steps to enter","Wide entrance","Extra space around bed","Accessible-height bed","No stairs or steps to enter","Wide doorway to guest bathroom","Bathtub with bath chair","Accessible-height toilet","Host greets you","Handheld shower head","Roll-in shower"}18.0353.048.078.01.0Real Bed1.00.03.01.02.00.0moderate$15.001business$15.002010-08-181.0tff2009-11-16['email', 'phone', 'facebook', 'reviews']13913.0ft2019-06-102019-09-1551.56802-0.1112129.01.0$1,176.00LB of IslingtonIslington16.02.0$65.00Apartmentfff9.09.010.010.09.096.09.00.14Private room$100.00$333.00
22.0{TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water",Microwave,"Coffee maker","Dishes and silverware","Luggage dropoff allowed","Long term stays allowed",Other}8.0114.08.08.01.0Real Bed1.01.01.01.00.00.0strict_14_with_grace_period$50.002romantic$0.002009-12-212.0ttt2009-12-05['email', 'phone', 'reviews', 'jumio', 'government_id']15400.0tt2019-08-272019-09-1551.48796-0.1689850.030.0$2,250.00ChelseaKensington and Chelsea87.06.0$100.00Apartmentttf10.010.010.010.010.096.09.00.73Entire home/apt$150.00$600.00
36.0{TV,Wifi,Kitchen,"Paid parking off premises",Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Bed linens",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"}12.0265.036.054.02.0Real Bed3.04.015.015.00.00.0strict_14_with_grace_period$65.003none$10.002011-03-214.0ttt2010-01-04['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual', 'work_email']17402.0tt2019-06-192019-09-1551.52098-0.14002365.03.0NaNCity of WestminsterWestminster41.05.0$300.00Apartmentfff10.09.09.09.010.094.09.00.40Entire home/apt$350.00$1,378.00
42.0{TV,"Cable TV",Internet,Wifi,Kitchen,"Free parking on premises","Pets allowed","Pets live on this property","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Long term stays allowed"}11.0346.041.071.01.5Real Bed1.01.01.01.00.00.0moderate$70.004family$0.002010-11-152.0ttf2009-09-28['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']24328.0ft2019-06-082019-09-1551.47298-0.163761125.030.0$3,500.00LB of WandsworthWandsworth93.01.0$175.00Townhousettf10.010.010.010.09.098.09.00.86Entire home/apt$250.00$1,050.00
54.0{TV,Wifi,Kitchen,"Free parking on premises",Elevator,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Host greets you"}0.0147.024.054.01.0Real Bed2.02.01.01.00.00.0moderate$50.005none$11.002016-03-052.0tff2010-04-03['email', 'phone', 'reviews']25023.0tt2019-07-252019-09-1551.44687-0.218741125.090.0$2,515.00LB of WandsworthWandsworth31.05.0$65.00Apartmentfff10.09.09.010.09.092.09.00.72Entire home/apt$250.00$630.00
62.0{Wifi,Kitchen,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"}12.0288.012.026.01.5Real Bed1.01.03.00.03.00.0strict_14_with_grace_period$0.006none$8.002010-04-141.0tft2010-04-05['email', 'phone', 'reviews', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']25123.0tt2019-06-282019-09-1551.57224-0.209061120.010.0$795.00LB of BarnetBarnet122.05.0$29.00Housefff10.010.010.010.09.095.010.01.06Private room$100.00$195.00
74.0{TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Coffee maker",Refrigerator,"Luggage dropoff allowed","Long term stays allowed","Host greets you"}13.0339.034.064.01.0Real Bed1.03.03.03.00.00.0strict_14_with_grace_period$75.007none$15.002010-11-023.0ttf2010-04-19['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']26223.0tt2019-07-222019-09-1551.54168-0.10207365.03.0$2,747.00LB of IslingtonIslington63.09.0$147.00Apartmentfff8.09.09.09.09.085.08.00.58Entire home/apt$100.00$727.00
82.0{TV,Wifi,Kitchen,"Paid parking off premises",Breakfast,Heating,Washer,"Smoke detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50","Hot water",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Garden or backyard","Host greets you"}1.0336.031.061.01.5Real Bed1.01.02.00.02.00.0strict_14_with_grace_period$10.008none$12.002010-07-011.0ttt2010-05-29['email', 'phone', 'facebook', 'reviews', 'jumio', 'offline_government_id', 'government_id']31361.0ft2019-06-302019-09-1551.534840.0270730.01.0$868.00LB of NewhamNewham115.010.0$34.00Townhousettf10.010.010.010.09.097.010.01.03Private roomNaN$231.00
92.0{Wifi,Kitchen,"Pets live on this property",Cat(s),"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,"Self check-in","Building staff","Hot water"}30.0365.060.090.01.0Real Bed1.01.01.00.01.00.0flexibleNaN9none$0.002010-10-161.0ttf2010-06-14['email', 'phone', 'reviews', 'jumio', 'offline_government_id', 'government_id']33332.0ft2019-05-262019-09-1551.46507-0.3242121.01.0NaNLB of HounslowHounslow5.02.0$100.00Housefff9.010.010.010.010.088.08.00.05Private roomNaNNaN

Last rows

accommodatesamenitiesavailability_30availability_365availability_60availability_90bathroomsbed_typebedroomsbedscalculated_host_listings_countcalculated_host_listings_count_entire_homescalculated_host_listings_count_private_roomscalculated_host_listings_count_shared_roomscancellation_policycleaning_feedf_indexexperiences_offeredextra_peoplefirst_reviewguests_includedhost_has_profile_pichost_identity_verifiedhost_is_superhosthost_sincehost_verificationsidinstant_bookableis_location_exactlast_reviewlast_scrapedlatitudelongitudemaximum_nightsminimum_nightsmonthly_priceneighbourhoodneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typerequire_guest_phone_verificationrequire_guest_profile_picturerequires_licensereview_scores_accuracyreview_scores_checkinreview_scores_cleanlinessreview_scores_communicationreview_scores_locationreview_scores_ratingreview_scores_valuereviews_per_monthroom_typesecurity_depositweekly_price
852631.0{TV,Wifi,"Air conditioning",Kitchen,"Pets allowed",Heating,"Smoke detector",Essentials,"Hair dryer",Iron}23.0173.053.083.01.0Real Bed1.01.01.01.00.00.0flexibleNaN85264none$0.00NaN1.0tff2019-09-14['phone']38610705.0tfNaN2019-09-1551.561630.073091125.01.0NaNLB of RedbridgeRedbridge0.00.0$101.00HousefffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaNNaN
852644.0{TV,Wifi,Kitchen,"Free parking on premises","Pets allowed",Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Private entrance","Hot water"}0.0307.02.032.01.0Real Bed2.02.01.01.00.00.0flexibleNaN85265none$0.00NaN1.0tff2016-06-12['email', 'phone', 'facebook', 'reviews']38610995.0tfNaN2019-09-1551.42155-0.314521125.02.0NaNLB of Richmond upon ThamesRichmond upon Thames0.00.0$105.00HousefffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaNNaN
852652.0{TV,Wifi,Kitchen,"Free parking on premises",Heating,Washer,"Smoke detector","First aid kit","Fire extinguisher",Essentials,Hangers,Iron,"Laptop friendly workspace","Private entrance","Hot water"}23.080.044.066.01.0Real Bed1.02.01.01.00.00.0flexibleNaN85266none$0.00NaN1.0tff2015-07-16['email', 'phone', 'reviews']38611275.0tfNaN2019-09-1551.42874-0.047861125.01.0NaNSydenhamLewisham0.00.0$78.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaNNaN
852662.0{Wifi,Kitchen,"Free parking on premises","Pets allowed",Breakfast,Heating,Washer,Essentials,Shampoo,Hangers,"Laptop friendly workspace","Private entrance","Dishes and silverware"}13.073.043.073.01.0Real Bed1.01.01.01.00.00.0strict_14_with_grace_period$0.0085267none$0.00NaN1.0tff2019-05-05['email', 'phone']38611320.0ttNaN2019-09-1551.62711-0.125021125.02.0NaNLB of EnfieldEnfield0.00.0$30.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt$100.00NaN
852672.0{Wifi,Kitchen,Washer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}15.030.017.030.01.0Real Bed2.02.01.00.01.00.0flexibleNaN85268none$0.00NaN1.0tff2012-09-07['phone', 'reviews', 'jumio', 'government_id']38611907.0tfNaN2019-09-1551.51357-0.205631125.06.0NaNNotting HillKensington and Chelsea0.00.0$56.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNPrivate roomNaNNaN
852685.0{TV,Wifi,Kitchen,"Free parking on premises",Heating,Washer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron}7.045.020.038.01.5Real Bed1.03.07.07.00.00.0flexible$40.0085269none$0.00NaN1.0tff2018-07-27['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']38612345.0tfNaN2019-09-1551.51383-0.272881125.02.0NaNLB of EalingEaling0.00.0$85.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/apt$0.00NaN
852692.0{Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer","Laptop friendly workspace","Self check-in",Lockbox,"Hot water"}2.02.02.02.02.0Real Bed1.01.02.00.02.00.0flexibleNaN85270none$0.00NaN1.0tff2017-09-12['email', 'phone', 'jumio', 'offline_government_id', 'government_id']38612360.0ffNaN2019-09-1551.55569-0.212511125.01.0NaNHampsteadCamden0.00.0$35.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNPrivate roomNaNNaN
852706.0{TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises",Breakfast,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"}23.0173.053.083.04.0Real Bed3.03.01.01.00.00.0flexibleNaN85271none$0.00NaN1.0tff2019-09-14['email', 'phone', 'offline_government_id', 'selfie', 'government_id', 'identity_manual']38613001.0ftNaN2019-09-1551.49741-0.139011125.07.0NaNWestminsterWestminster0.00.0$420.00CondominiumfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaNNaN
852712.0{Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed",Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"}10.0233.023.053.01.0Real Bed1.01.01.00.01.00.0flexibleNaN85272none$0.00NaN1.0tff2019-09-14['email', 'phone']38613420.0ftNaN2019-09-1551.54849-0.4550415.01.0NaNLB of HillingdonHillingdon0.00.0$35.00HousefffNaNNaNNaNNaNNaNNaNNaNNaNPrivate room$81.00NaN
852725.0{TV,Wifi,Kitchen,Breakfast,Heating,Washer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo}2.032.015.032.01.0Real Bed2.02.03.02.01.00.0flexibleNaN85273none$0.00NaN1.0ttf2013-05-03['email', 'phone', 'google', 'reviews', 'jumio', 'government_id']38613719.0ftNaN2019-09-1551.42159-0.131397.02.0NaNLower StreathamLambeth0.00.0$50.00ApartmentfffNaNNaNNaNNaNNaNNaNNaNNaNEntire home/aptNaNNaN